A secure and reliable server is closely related to performing regular backups as failures will probably occur sometimes - caused by attacks, hardware failure, human error, power outages, etc.
Navicat allows you to backup/restore all tables and records, views, stored procedures and events for your MySQL, PostgreSQL and SQLite databases. Backup can be invoked from the command line, which makes it possible to schedule backups between databases/schemas.
Just simply click to open an object pane for Backup. A control-click displays
the popup menu or using the object pane toolbar below, allowing you to create
new, restore, extract and delete the backup.
Create Backup
To create a new backup
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Backup from the popup menu.
- Edit backup properties on the appropriate tabs.
- Click Start.
Hint: To create new backup you can also control-click the Backups node of the navigation pane and select the New Backup from the popup menu.
To change the name of the backup
- Select the backup for editing in the navigation pane/object pane.
- Control-click and select the Rename from the popup menu.
Delete Backup
To delete a backup
- Select the backup for deleting in the navigation pane/object pane.
- Control-click and select the Delete Backup from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Restore Backup
To restore a backup to an existing database
- Open the database and select the existing backup.
- Control-click and select Restore Backup from the popup menu.
- Edit restore options on the appropriate tabs.
- Click Start.
Hint: To restore the backup you can also control-click the Backup node of the navigation pane and select the Restore Backup from the popup menu.
To restore a backup to a new database
- Create a new database (MySQL or PostgreSQL or SQLite) and click
to open an object pane for Backup.
- Control-click anywhere on the object pane and select Restore Backup from the popup menu.
- Browse the backup file.
- Edit restore options on the appropriate tabs.
- Click Start.
Extract SQL
To extract backup to sql file
- Select the backup for extracting in the navigation pane/object pane.
- Control-click and select the Extract SQL from the popup menu.
- Save the sql file to your destination.
Achieve Backup Information
To achieve a backup information (Name, File Size and Update Time etc)
- Select the backup in the navigation pane/object pane.
- Choose View -> Object Information in the main menu.
or - Click the
from the object pane toolbar.